|
OLAP Data Storage Methods
Dittrich, Petr ; Kroulík, Jan (referee) ; Hruška, Tomáš (advisor)
The topic of the bachelor work is the OLAP core implementation for the data storage space. All theoretical facts about the data storage space are discussed at the start. The form of metadata elements storage and the OLAP cubes creating are described in the following part. And finally, in the last chapter, it is precisely shown how to create a cube in this system.
|
|
E-commerce System Database Migration
Zkoumalová, Barbora ; Weirich, Pavel (referee) ; Luhan, Jan (advisor)
The object of master‘s thesis is design and creation of e-commerce system database migration tool from the ZenCart platform to the PrestaShop platform. Both system databases will be described and analysed and based on gained information the migration tool will be created according customers‘ requirements and then final data migration from original to the new database will be executed.
|
| |
| |
|
Design of Data Warehouse in SaaS Company
Zetocha, Adam ; Šimek, Dominik (referee) ; Kříž, Jiří (advisor)
The diploma thesis consists of design and steps leading to build of data warehouse in startup developing SaaS product. Theoretical information about data warehouses and business intelligence are projected into design and following process of data warehouse development mainly for marketing data. Importing process of data into a data warehouse and reporting are fully automated.
|
|
Data Cube Visualization
Dittrich, Petr ; Kupčík, Jan (referee) ; Hruška, Tomáš (advisor)
The topic of the master's thesis is a concept and implementation of the prototype application TOPZ demostrating the data warehouse. All theoretical facts about the data storage space are discussed at first. It is also specified the areas of possible improvements of the data warehouse. The specification of requirements and concept of the demonstration application are described in the following part. Testing the performace of the data warehouse is discussed in last chapter.
|
|
Implementation of OLAP Analysis for BUT Libraries
Mahdalíček, Josef ; Ruttkay, Ladislav (referee) ; Šárfy, Martin (advisor)
The aim of this project is to create tool for OLAP analysis over operational data of BUT libraries. This OLAP tool answers ie. query how long were users having loaned books. These queries could be specified by time period (year, month), library (ie. FIT library) and other dimensions. Only some, for this application interesting, tables from source database are used. Tables were exported into text files in csv format. According to project specification, system for OLAP analysis should be open source. Tool Mondrian accomplishes this requirement and was used in this work. Data warehouse is represented by relational database MySQL. ETL tool feeds data warehouse by data from exported files. User interface is used from internet browser and is implemented by component JPivot. Query results are displayed in tables and graphs.
|
| |
|
Association Rules Mining over Data Warehouses
Hlavička, Ladislav ; Chmelař, Petr (referee) ; Stryka, Lukáš (advisor)
This thesis deals with association rules mining over data warehouses. In the first part the reader will be familiarized with terms like knowledge discovery in databases and data mining. The following part of the work deals with data warehouses. Further the association analysis, the association rules, their types and mining possibilities are described. The architecture of Microsoft SQL Server and its tools for working with data warehouses are presented. The rest of the thesis includes description and analysis of the Star-miner algorithm, design, implementation and testing of the application.
|
|
Comparison of functionality of the standard BI platform and BI module integrated in the ERP system
Fargačová, Tamara ; Klčová, Hana (referee) ; Sodomka, Petr (advisor)
This master’s thesis deals with comparison of the standard Business Intelligence platform specifically IBM Cognos BI and BI module integrated in the ERP system QI. In the first part it defines basic concepts of this topic and describes the life cycle of business information systems with emphasis on Business Intelligence. In the next part current situation on the market of these platforms and BI tools which create management information systems is described. Both types of BI solutions are compared with concentration on standard functionality usage. It also describes their ability to analyze through using data warehouse technology, integration with third-party products and business and economic aspects.
|